<?php

include_once("../../php/include_all.php");
$iduskpd = $_GET['id_uskpd'];

$uskpd=get_data("select nama_kegiatan, indikator_program, indikator_keluaran, indikator_hasil, target_hasil, tahun 
from mus_usulan_skpd U, mus_kegiatan K, mus_program P 
where P.id_program=K.id_program and U.id_kegiatan=K.id_keg and id_uskpd=$iduskpd");
$rinudeda = get_datas ("select usulan, lokasi, valume, apbdkab, apbdprov, apbn, prioritas from mus_rinc_usulan_skpd r, mus_usulan_skpd u where u.id_uskpd=r.id_uskpd and r.id_uskpd=$iduskpd order by r.id_rinc_usulan_skpd");
		//printf($rinudeda);
	
echo "
	<table class='table-form'>
		<tr>
			<td>Kegiatan</td><td>:</td><td>".$uskpd['nama_kegiatan']."</td>
		</tr>
		<tr>
			<td>Indikator Hasil Program</td><td>:</td><td>".$uskpd['indikator_program']."</td>
		</tr>
		<tr>
			<td>Indikator Keluaran</td><td>:</td><td>".$uskpd['indikator_keluaran']."</td>
		</tr>
		<tr>
			<td>Indikator Hasil Kegiatan</td><td>:</td><td>".$uskpd['indikator_hasil']."</td>
		</tr>
		<tr>
			<td>Target</td><td>:</td><td>".$uskpd['target_hasil']."</td>
		</tr>
		<tr>
			<td>Tahun</td><td>:</td><td>".$uskpd['tahun']."</td>
		</tr>
	</table>
	<br>
	<table class='table table-bordered' align='center'>
		<tr>
			
			<th style='text-align:center'>LOKASI</th>
			<th style='text-align:center'>VOLUME</th>
			<th style='text-align:center'>APBD KAB.</th>
			<th style='text-align:center'>APBD PROV.</th>
			<th style='text-align:center'>APBN</th>
			<th style='text-align:center'>PRIORITAS</th>
			<th style='text-align:center'>STATUS</th>
		</tr>
		";
		//$no=1;
		foreach ($rinudeda as $are){
			echo "<tr>
				<tbody>
				<td>".$are['lokasi']."</td>
				<td style='text-align:center'>".$are['valume']."</td>
				<td style='text-align:right'>".$are['apbdkab']."</td>
				<td style='text-align:right'>".$are['apbdprov']."</td>
				<td style='text-align:right'>".$are['apbn']."</td>
				<td style='text-align:center'>".$are['prioritas']."</td>
				<td style='text-align:center'>".$are['status']."</td>
			</tr></tbody>";
			//$no++;
		} echo "
	</table>
";
?>